{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Risk Analysis ENPV"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":2,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Risk Analysis ENPV","index":0,"n_rows":85,"n_cols":14,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Assumptions - Triangular Probability Distributions"]
[null,null,"Base-case ENPV",null,"mEUR",{"$f":"+'[1]Output-economic'!$G$27/1000000","v":67.015543713516664}]
[null,null,"Variables",null,null,"Investment","O&M","Benefits"]
[null,null,"Base-case (Present Value)",null,{"$f":"E3","v":"mEUR"},{"$f":"+'[2]Output-economic'!$G$16/1000000+'[2]Output-economic'!$G$18/1000000","v":90.275656483283214},{"$f":"+'[2]Output-economic'!$G$17/1000000","v":164.73898251669428},{"$f":"+'[2]Output-economic'!$G$12/1000000","v":322.03018271349418}]
[null,null,"Minimum",null,"%",0.8,0.8,0.5]
[null,null,"Most Likely (Mode)",null,"%",1,1,1]
[null,null,"Maximum",null,"%",1,1,1.1000000000000001]
[null,null,"Number of iterations",null,"#",10000]
[]
[]
[null,null,"Results of Monte Carlo Simulation - ENPV"]
[null,null,null,null,"Mean (Expected ENPV)",null,{"$f":"E3","v":"mEUR"},40.029332236020046,null,null,"Minimum",null,{"$f":"E3","v":"mEUR"},-83.131219850131671]
[null,null,null,null,"Median",null,{"$f":"E3","v":"mEUR"},45.432449012822232,null,null,"Maximum",null,{"$f":"E3","v":"mEUR"},138.58348808014642]
[null,null,null,null,"Standard Deviation",null,{"$f":"E3","v":"mEUR"},43.226589929848686,null,null,"Prob. {ENPV>0}",null,"%",0.80310000000000004]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Auxiliary data for charts"]
[null,null,null,"ENPV"]
[null,null,null,"from","to","mid","obs.","freq.",null,"cum freq"]
[null,null,"low",-83.131219850131671,-77.72354404695416,{"$f":"dumping","v":-83.131219850131671},13,{"$f":"G45/(SUM(G$45:G$85))","v":1.2999999999999999E-3},null,{"$f":"H45","v":1.2999999999999999E-3}]
[null,null,null,-77.72354404695416,-72.315868243776649,{"$f":"AVERAGE(D46:E46)","v":-75.019706145365404},17,{"$f":"G46/(SUM(G$45:G$85))","v":1.6999999999999999E-3},null,{"$f":"J45+H46","v":3.0000000000000001E-3}]
[null,null,null,-72.315868243776649,-66.908192440599137,-69.612030342187893,28,2.8E-3,null,5.7999999999999996E-3]
[null,null,null,-66.908192440599137,-61.500516637421626,-64.204354539010382,49,4.8999999999999998E-3,null,1.0699999999999999E-2]
[null,null,null,-61.500516637421626,-56.092840834244114,-58.79667873583287,65,6.4999999999999997E-3,null,1.72E-2]
[null,null,null,-56.092840834244114,-50.685165031066603,-53.389002932655359,90,8.9999999999999993E-3,null,2.6200000000000001E-2]
[null,null,null,-50.685165031066603,-45.277489227889092,-47.981327129477847,88,8.8000000000000005E-3,null,3.5000000000000003E-2]
[null,null,null,-45.277489227889092,-39.86981342471158,-42.573651326300336,113,1.1299999999999999E-2,null,4.6300000000000001E-2]
[null,null,null,-39.86981342471158,-34.462137621534069,-37.165975523122825,149,1.49E-2,null,6.1200000000000004E-2]
[null,null,null,-34.462137621534069,-29.054461818356554,-31.758299719945313,170,1.7000000000000001E-2,null,7.8200000000000006E-2]
[null,null,null,-29.054461818356554,-23.646786015179039,-26.350623916767795,193,1.9300000000000001E-2,null,9.7500000000000003E-2]
[null,null,null,-23.646786015179039,-18.239110212001524,-20.942948113590283,195,1.95E-2,null,0.11700000000000001]
[null,null,null,-18.239110212001524,-12.831434408824009,-15.535272310412767,219,2.1899999999999999E-2,null,0.1389]
[null,null,null,-12.831434408824009,-7.4237586056464941,-10.127596507235252,253,2.53E-2,null,0.16419999999999998]
[null,null,null,-7.4237586056464941,-2.0160828024689792,-4.7199207040577367,223,2.23E-2,null,0.1865]
[null,null,null,-2.0160828024689792,3.3915930007085358,0.68775509911977828,288,2.8799999999999999E-2,null,0.21529999999999999]
[null,null,null,3.3915930007085358,8.7992688038860507,6.0954309022972932,300,0.03,null,0.24529999999999999]
[null,null,null,8.7992688038860507,14.206944607063566,11.503106705474808,317,3.1699999999999999E-2,null,0.27699999999999997]
[null,null,null,14.206944607063566,19.614620410241081,16.910782508652325,363,3.6299999999999999E-2,null,0.31329999999999997]
[null,null,null,19.614620410241081,25.022296213418596,22.318458311829836,377,3.7699999999999997E-2,null,0.35099999999999998]
[null,null,"mid",25.022296213418596,30.429972016596111,27.726134115007355,360,3.5999999999999997E-2,null,0.38699999999999996]
[null,null,null,30.429972016596111,35.837647819773622,33.133809918184866,369,3.6900000000000002E-2,null,0.42389999999999994]
[null,null,null,35.837647819773622,41.245323622951133,38.541485721362378,437,4.3700000000000003E-2,null,0.46759999999999996]
[null,null,null,41.245323622951133,46.652999426128645,43.949161524539889,405,4.0500000000000001E-2,null,0.5081]
[null,null,null,46.652999426128645,52.060675229306156,49.3568373277174,396,3.9600000000000003E-2,null,0.54769999999999996]
[null,null,null,52.060675229306156,57.468351032483667,54.764513130894912,427,4.2700000000000002E-2,null,0.59039999999999992]
[null,null,null,57.468351032483667,62.876026835661179,60.172188934072423,505,5.0500000000000003E-2,null,0.64089999999999991]
[null,null,null,62.876026835661179,68.28370263883869,65.579864737249935,481,4.8099999999999997E-2,null,0.68899999999999995]
[null,null,null,68.28370263883869,73.691378442016202,70.987540540427446,519,5.1900000000000002E-2,null,0.74089999999999989]
[null,null,null,73.691378442016202,79.099054245193713,76.395216343604957,492,4.9200000000000001E-2,null,0.79009999999999991]
[null,null,null,79.099054245193713,84.506730048371224,81.802892146782469,482,4.82E-2,null,0.83829999999999993]
[null,null,null,84.506730048371224,89.914405851548736,87.21056794995998,443,4.4299999999999999E-2,null,0.88259999999999994]
[null,null,null,89.914405851548736,95.322081654726247,92.618243753137492,409,4.0899999999999999E-2,null,0.92349999999999999]
[null,null,null,95.322081654726247,100.72975745790376,98.025919556315003,282,2.8199999999999999E-2,null,0.95169999999999999]
[null,null,null,100.72975745790376,106.13743326108127,103.43359535949251,211,2.1100000000000001E-2,null,0.9728]
[null,null,null,106.13743326108127,111.54510906425878,108.84127116267003,146,1.46E-2,null,0.98739999999999994]
[null,null,null,111.54510906425878,116.95278486743629,114.24894696584754,71,7.1000000000000004E-3,null,0.99449999999999994]
[null,null,null,116.95278486743629,122.3604606706138,119.65662276902505,42,4.1999999999999997E-3,null,0.99869999999999992]
[null,null,null,122.3604606706138,127.76813647379132,125.06429857220256,9,8.9999999999999998E-4,null,0.99959999999999993]
[null,null,null,127.76813647379132,133.17581227696883,130.47197437538006,2,2.0000000000000001E-4,null,0.99979999999999991]
[null,null,"high",133.17581227696883,138.58348808014642,{"$f":"E85","v":138.58348808014642},2,2.0000000000000001E-4,null,0.99999999999999989]